
<!DOCTYPE HTML>
<html lang="zh-hans" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>mysql · Aivin开发笔记</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="Aivin">
        
        
    
    <link rel="stylesheet" href="../gitbook/style.css">

    
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-search-plus/search.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-anchor-navigation-ex/style/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-fontsettings/website.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-tbfed-pagefooter/footer.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-donate/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-local-video/video-js.min.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-splitter/splitter.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-highlight/website.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-theme-comscore/test.css">
                
            
        

    

    
        
        <link rel="stylesheet" href="../styles/website.css">
        
    

        
    
    
    
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="zookeeper.html" />
    
    
    <link rel="prev" href="tomcat.html" />
    

    
        <link rel="shortcut icon" href='../assets/images/favicon.ico' type="image/x-icon">
    
    
        <link rel="bookmark" href='../assets/images/favicon.ico' type="image/x-icon">
    
    
    

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
<div id="book-search-input" role="search">
    <input type="text" placeholder="输入并搜索" />
</div>

            
                <nav role="navigation">
                


<ul class="summary">
    
    

    

    
        
        
    
        <li class="chapter " data-level="1.1" data-path="../">
            
                <a href="../">
            
                    
                    说明
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2" data-path="开发规范.html">
            
                <a href="开发规范.html">
            
                    
                    开发规范
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3" data-path="tomcat.html">
            
                <a href="tomcat.html">
            
                    
                    框架类
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.3.1" data-path="tomcat.html">
            
                <a href="tomcat.html">
            
                    
                    tomcat
            
                </a>
            

            
        </li>
    
        <li class="chapter active" data-level="1.3.2" data-path="mysql.html">
            
                <a href="mysql.html">
            
                    
                    mysql
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.3" data-path="zookeeper.html">
            
                <a href="zookeeper.html">
            
                    
                    zookeeper
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.4" data-path="hadoop.html">
            
                <a href="hadoop.html">
            
                    
                    hadoop
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.5" data-path="springBoot.html">
            
                <a href="springBoot.html">
            
                    
                    springBoot
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.6" data-path="springcloud.html">
            
                <a href="springcloud.html">
            
                    
                    springcloud
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.7" data-path="mybatis.html">
            
                <a href="mybatis.html">
            
                    
                    mybatis
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.8" data-path="nginx.html">
            
                <a href="nginx.html">
            
                    
                    nginx
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.9" data-path="redis.html">
            
                <a href="redis.html">
            
                    
                    redis
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.10" data-path="swagger.html">
            
                <a href="swagger.html">
            
                    
                    swagger
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.3.11" data-path="jenkins.html">
            
                <a href="jenkins.html">
            
                    
                    jenkins
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            本书使用 GitBook 发布
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    

<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href=".." >mysql</a>
    </h1>
</div>




                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
<div class="search-plus" id="book-search-results">
    <div class="search-noresults">
    
                                <section class="normal markdown-section">
                                
                                <div id="anchor-navigation-ex-navbar"><i class="fa fa-navicon"></i><ul><li><span class="title-icon "></span><a href="#mysql"><b>1. </b>mysql</a></li><ul><li><span class="title-icon "></span><a href="#&#x5E38;&#x7528;sql&#x8BED;&#x53E5;"><b>1.1. </b>&#x5E38;&#x7528;sql&#x8BED;&#x53E5;</a></li><ul><li><span class="title-icon "></span><a href="#&#x590D;&#x5236;&#x8868;&#x6570;&#x636E;&#x5230;&#x65B0;&#x8868;"><b>1.1.1. </b>&#x590D;&#x5236;&#x8868;&#x6570;&#x636E;&#x5230;&#x65B0;&#x8868;</a></li><li><span class="title-icon "></span><a href="#&#x591A;&#x8868;&#x5408;&#x5E76;&#x53BB;&#x91CD;"><b>1.1.2. </b>&#x591A;&#x8868;&#x5408;&#x5E76;&#x53BB;&#x91CD;</a></li><li><span class="title-icon "></span><a href="#mysql-&#x8BA9;id&#x4ECE;1&#x5F00;&#x59CB;&#x81EA;&#x52A8;&#x589E;&#x957F;"><b>1.1.3. </b>mysql &#x8BA9;id&#x4ECE;1&#x5F00;&#x59CB;&#x81EA;&#x52A8;&#x589E;&#x957F;</a></li><li><span class="title-icon "></span><a href="#&#x5206;&#x9875;&#x67E5;&#x8BE2;"><b>1.1.4. </b>&#x5206;&#x9875;&#x67E5;&#x8BE2;</a></li></ul><li><span class="title-icon "></span><a href="#&#x6570;&#x636E;&#x5E93;&#x5E2E;&#x52A9;&#x7C7B;"><b>1.2. </b>&#x6570;&#x636E;&#x5E93;&#x5E2E;&#x52A9;&#x7C7B;</a></li><li><span class="title-icon "></span><a href="#&#x5E38;&#x7528;&#x51FD;&#x6570;"><b>1.3. </b>&#x5E38;&#x7528;&#x51FD;&#x6570;</a></li><ul><li><span class="title-icon "></span><a href="#&#x589E;&#x52A0;&#x8BB0;&#x5F55;"><b>1.3.1. </b>&#x589E;&#x52A0;&#x8BB0;&#x5F55;</a></li></ul></ul></ul></div><a href="#mysql" id="anchorNavigationExGoTop"><i class="fa fa-arrow-up"></i></a><h1 id="mysql"><a name="mysql" class="anchor-navigation-ex-anchor" href="#mysql"><i class="fa fa-link" aria-hidden="true"></i></a>1. mysql</h1>
<h2 id="&#x5E38;&#x7528;sql&#x8BED;&#x53E5;"><a name="&#x5E38;&#x7528;sql&#x8BED;&#x53E5;" class="anchor-navigation-ex-anchor" href="#&#x5E38;&#x7528;sql&#x8BED;&#x53E5;"><i class="fa fa-link" aria-hidden="true"></i></a>1.1. &#x5E38;&#x7528;sql&#x8BED;&#x53E5;</h2>
<h3 id="&#x590D;&#x5236;&#x8868;&#x6570;&#x636E;&#x5230;&#x65B0;&#x8868;"><a name="&#x590D;&#x5236;&#x8868;&#x6570;&#x636E;&#x5230;&#x65B0;&#x8868;" class="anchor-navigation-ex-anchor" href="#&#x590D;&#x5236;&#x8868;&#x6570;&#x636E;&#x5230;&#x65B0;&#x8868;"><i class="fa fa-link" aria-hidden="true"></i></a>1.1.1. &#x590D;&#x5236;&#x8868;&#x6570;&#x636E;&#x5230;&#x65B0;&#x8868;</h3>
<pre><code class="lang-sql"><span class="hljs-keyword">INSERT</span> <span class="hljs-keyword">INTO</span> &#x65B0;&#x8868;(&#x5B57;&#x6BB5;<span class="hljs-number">1</span>,&#x5B57;&#x6BB5;<span class="hljs-number">2</span>,&#x2026;&#x2026;.) <span class="hljs-keyword">SELECT</span> &#x5B57;&#x6BB5;<span class="hljs-number">1</span>,&#x5B57;&#x6BB5;<span class="hljs-number">2</span>,&#x2026;&#x2026; <span class="hljs-keyword">FROM</span> &#x65E7;&#x8868;
&#x6216;
<span class="hljs-keyword">CREATE</span> <span class="hljs-keyword">TABLE</span> &#x65B0;&#x8868;  <span class="hljs-keyword">LIKE</span> &#x65E7;&#x8868; <span class="hljs-keyword">INSERT</span> <span class="hljs-keyword">INTO</span> recommendpicvdebug <span class="hljs-keyword">SELECT</span> * <span class="hljs-keyword">FROM</span> recommendpicv3
</code></pre>
<h3 id="&#x591A;&#x8868;&#x5408;&#x5E76;&#x53BB;&#x91CD;"><a name="&#x591A;&#x8868;&#x5408;&#x5E76;&#x53BB;&#x91CD;" class="anchor-navigation-ex-anchor" href="#&#x591A;&#x8868;&#x5408;&#x5E76;&#x53BB;&#x91CD;"><i class="fa fa-link" aria-hidden="true"></i></a>1.1.2. &#x591A;&#x8868;&#x5408;&#x5E76;&#x53BB;&#x91CD;</h3>
<p>InnoDB &#x548C; MyISAM&#x3002;&#x9009;&#x62E9;&#x4E3A;MyISAM&#x3002;</p>
<pre><code class="lang-sql"><span class="hljs-keyword">INSERT</span> <span class="hljs-keyword">INTO</span> userall
<span class="hljs-keyword">SELECT</span> t.uid, t.userName
<span class="hljs-keyword">FROM</span> starbeaninfo4 t
<span class="hljs-keyword">WHERE</span> t.uid <span class="hljs-keyword">NOT</span> <span class="hljs-keyword">IN</span> (
    <span class="hljs-keyword">SELECT</span> uid
    <span class="hljs-keyword">FROM</span> userall
)
</code></pre>
<h3 id="mysql-&#x8BA9;id&#x4ECE;1&#x5F00;&#x59CB;&#x81EA;&#x52A8;&#x589E;&#x957F;"><a name="mysql-&#x8BA9;id&#x4ECE;1&#x5F00;&#x59CB;&#x81EA;&#x52A8;&#x589E;&#x957F;" class="anchor-navigation-ex-anchor" href="#mysql-&#x8BA9;id&#x4ECE;1&#x5F00;&#x59CB;&#x81EA;&#x52A8;&#x589E;&#x957F;"><i class="fa fa-link" aria-hidden="true"></i></a>1.1.3. mysql &#x8BA9;id&#x4ECE;1&#x5F00;&#x59CB;&#x81EA;&#x52A8;&#x589E;&#x957F;</h3>
<pre><code class="lang-sql"><span class="hljs-keyword">truncate</span> <span class="hljs-keyword">table</span> <span class="hljs-keyword">test</span>
</code></pre>
<h3 id="&#x5206;&#x9875;&#x67E5;&#x8BE2;"><a name="&#x5206;&#x9875;&#x67E5;&#x8BE2;" class="anchor-navigation-ex-anchor" href="#&#x5206;&#x9875;&#x67E5;&#x8BE2;"><i class="fa fa-link" aria-hidden="true"></i></a>1.1.4. &#x5206;&#x9875;&#x67E5;&#x8BE2;</h3>
<pre><code class="lang-sql"><span class="hljs-keyword">SELECT</span> *
<span class="hljs-keyword">FROM</span> newsentity_table
<span class="hljs-keyword">WHERE</span> (usertype = <span class="hljs-string">&apos;base&apos;</span>
        <span class="hljs-keyword">OR</span> usertype = <span class="hljs-string">&apos;salse&apos;</span>)
    <span class="hljs-keyword">AND</span> logindate <span class="hljs-keyword">IS</span> <span class="hljs-keyword">NOT</span> <span class="hljs-literal">NULL</span>
<span class="hljs-keyword">ORDER</span> <span class="hljs-keyword">BY</span> logindate <span class="hljs-keyword">DESC</span>
<span class="hljs-keyword">LIMIT</span> &#x8D77;&#x59CB;&#x884C;, &#x6BCF;&#x9875;&#x591A;&#x5C11;&#x884C;
</code></pre>
<h2 id="&#x6570;&#x636E;&#x5E93;&#x5E2E;&#x52A9;&#x7C7B;"><a name="&#x6570;&#x636E;&#x5E93;&#x5E2E;&#x52A9;&#x7C7B;" class="anchor-navigation-ex-anchor" href="#&#x6570;&#x636E;&#x5E93;&#x5E2E;&#x52A9;&#x7C7B;"><i class="fa fa-link" aria-hidden="true"></i></a>1.2. &#x6570;&#x636E;&#x5E93;&#x5E2E;&#x52A9;&#x7C7B;</h2>
<pre><code class="lang-java"><span class="hljs-keyword">public</span> <span class="hljs-class"><span class="hljs-keyword">class</span> <span class="hljs-title">DBUtil</span></span>{
  <span class="hljs-function"><span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> <span class="hljs-keyword">void</span> <span class="hljs-title">closeConection</span><span class="hljs-params">(Connection conn, ResultSet rs, PreparedStatement pstm)</span>
    <span class="hljs-keyword">throws</span> SQLException</span>{
    <span class="hljs-keyword">if</span> (rs != <span class="hljs-keyword">null</span>) {
      rs.close();
    }
    <span class="hljs-keyword">if</span> (pstm != <span class="hljs-keyword">null</span>) {
      pstm.close();
    }

    <span class="hljs-keyword">if</span> ((conn != <span class="hljs-keyword">null</span>) &amp;&amp; (!conn.isClosed()))
      <span class="hljs-keyword">try</span> {
        conn.close();
      } <span class="hljs-keyword">catch</span> (Exception e) {
        e.printStackTrace();
      }
  }

  <span class="hljs-function"><span class="hljs-keyword">public</span> <span class="hljs-keyword">static</span> Connection <span class="hljs-title">getConnection</span><span class="hljs-params">()</span> </span>{
    Connection conn = <span class="hljs-keyword">null</span>;
    String URL = <span class="hljs-string">&quot;jdbc:mysql://114.67.234.65:3306/aivininfo?useUnicode=true&amp;characterEncoding=UTF-8&amp;useSSL=true&quot;</span>;
    <span class="hljs-keyword">try</span>{
      Class.forName(<span class="hljs-string">&quot;org.gjt.mm.mysql.Driver&quot;</span>);
      conn = DriverManager.getConnection(URL, <span class="hljs-string">&quot;aivin&quot;</span>,  <span class="hljs-string">&quot;Hnyer88888888&quot;</span>);
    }
    <span class="hljs-keyword">catch</span> (Exception e) {
      e.printStackTrace();
    }
    <span class="hljs-keyword">return</span> conn;
  }
}
</code></pre>
<h2 id="&#x5E38;&#x7528;&#x51FD;&#x6570;"><a name="&#x5E38;&#x7528;&#x51FD;&#x6570;" class="anchor-navigation-ex-anchor" href="#&#x5E38;&#x7528;&#x51FD;&#x6570;"><i class="fa fa-link" aria-hidden="true"></i></a>1.3. &#x5E38;&#x7528;&#x51FD;&#x6570;</h2>
<h3 id="&#x589E;&#x52A0;&#x8BB0;&#x5F55;"><a name="&#x589E;&#x52A0;&#x8BB0;&#x5F55;" class="anchor-navigation-ex-anchor" href="#&#x589E;&#x52A0;&#x8BB0;&#x5F55;"><i class="fa fa-link" aria-hidden="true"></i></a>1.3.1. &#x589E;&#x52A0;&#x8BB0;&#x5F55;</h3>
<pre><code class="lang-java"><span class="hljs-keyword">public</span> <span class="hljs-class"><span class="hljs-keyword">class</span> <span class="hljs-title">MyDbHelper</span> </span>{
    Connection conn;
    PreparedStatement pstm = <span class="hljs-keyword">null</span>;
    ResultSet rs = <span class="hljs-keyword">null</span>;
    String sqlStr;

    <span class="hljs-function"><span class="hljs-keyword">public</span> <span class="hljs-keyword">int</span> <span class="hljs-title">addRecommendPicRecord</span><span class="hljs-params">(String title, String content)</span> </span>{
        <span class="hljs-keyword">boolean</span> addUserSuccess = <span class="hljs-keyword">true</span>;
        <span class="hljs-keyword">long</span> addedRecodeId = -<span class="hljs-number">1L</span>;
        <span class="hljs-keyword">this</span>.conn = DBUtil.getConnection();
        <span class="hljs-keyword">this</span>.sqlStr = <span class="hljs-string">&quot;insert into aivinblog  ( blogTitle , blogContent ,updateTime)  values  ( ? ,? ,?)&quot;</span>;
        <span class="hljs-keyword">try</span> {
            <span class="hljs-keyword">this</span>.pstm = <span class="hljs-keyword">this</span>.conn.prepareStatement(<span class="hljs-keyword">this</span>.sqlStr,
                    Statement.RETURN_GENERATED_KEYS);
            <span class="hljs-keyword">this</span>.pstm.setString(<span class="hljs-number">1</span>, title);
            <span class="hljs-keyword">this</span>.pstm.setString(<span class="hljs-number">2</span>, content);
            <span class="hljs-keyword">this</span>.pstm.setString(<span class="hljs-number">3</span>, getCurrentDataStr());
            addUserSuccess = <span class="hljs-keyword">this</span>.pstm.executeUpdate() &gt; <span class="hljs-number">0</span>;

            ResultSet rs = <span class="hljs-keyword">this</span>.pstm.getGeneratedKeys();
            <span class="hljs-keyword">if</span> (rs.next())
                addedRecodeId = rs.getLong(<span class="hljs-number">1</span>);
        } <span class="hljs-keyword">catch</span> (SQLException e) {
            e.printStackTrace();
        } <span class="hljs-keyword">finally</span> {
        }
        <span class="hljs-keyword">try</span> {
            DBUtil.closeConection(<span class="hljs-keyword">this</span>.conn, <span class="hljs-keyword">this</span>.rs, <span class="hljs-keyword">this</span>.pstm);
        } <span class="hljs-keyword">catch</span> (SQLException e) {
            e.printStackTrace();
        }
        <span class="hljs-keyword">return</span> (<span class="hljs-keyword">int</span>) addedRecodeId;
    }

    <span class="hljs-function"><span class="hljs-keyword">public</span> String <span class="hljs-title">getCurrentDataStr</span><span class="hljs-params">()</span> </span>{
        DateFormat dateFormat = <span class="hljs-keyword">new</span> SimpleDateFormat(<span class="hljs-string">&quot;yyyy-MM-dd&quot;</span>,
                Locale.getDefault());
        String reslut = dateFormat.format(<span class="hljs-keyword">new</span> Date());
        <span class="hljs-keyword">return</span> reslut;
    }<span class="hljs-comment">//</span>
}
</code></pre>
<footer class="page-footer"><span class="copyright">&#x65E0;&#x7248;&#x6743; &#x53EF;&#x4EE5;&#x65E0;&#x9650;&#x5236;&#x4F7F;&#x7528;&#xFF01; all right reserved&#xFF0C;powered by Gitbook</span><span class="footer-modification">&#x8BE5;&#x6587;&#x4EF6;&#x66F4;&#x65B0;&#x65F6;&#x95F4;&#xFF1A;
2019-01-18 10:23:15
</span></footer>
                                
                                </section>
                            
    </div>
    <div class="search-results">
        <div class="has-results">
            
            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>
            
        </div>
        <div class="no-results">
            
            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
            
        </div>
    </div>
</div>

                        </div>
                    </div>
                
            </div>

            
                
                <a href="tomcat.html" class="navigation navigation-prev " aria-label="Previous page: tomcat">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
                <a href="zookeeper.html" class="navigation navigation-next " aria-label="Next page: zookeeper">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
        
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"mysql","level":"1.3.2","depth":2,"next":{"title":"zookeeper","level":"1.3.3","depth":2,"path":"chinese/zookeeper.md","ref":"chinese/zookeeper.md","articles":[]},"previous":{"title":"tomcat","level":"1.3.1","depth":2,"path":"chinese/tomcat.md","ref":"chinese/tomcat.md","articles":[]},"dir":"ltr"},"config":{"plugins":["-search","search-plus","todo","anchor-navigation-ex","copy-code-button","fontsettings","tbfed-pagefooter","donate","local-video","splitter","favicon","theme-comscore","local-video"],"styles":{"website":"styles/website.css"},"pluginsConfig":{"tbfed-pagefooter":{"copyright":"无版权 可以无限制使用！","modify_label":"该文件更新时间：","modify_format":"YYYY-MM-DD HH:mm:ss"},"todo":{},"splitter":{},"lunr":{"maxIndexSize":1000000,"ignoreSpecialCharacters":false},"donate":{"alipay":"http://oyru0ayig.bkt.clouddn.com/201803011956_osChina_支付宝收款码.png","alipayText":"支付宝打赏","button":"打赏","title":"","wechat":"http://oyru0ayig.bkt.clouddn.com/201803011956_osChina_微信收款码.png","wechatText":"微信打赏"},"fontsettings":{"family":"sans","size":2,"theme":"sepia"},"highlight":{},"anchor-navigation-ex":{"associatedWithSummary":true,"float":{"floatIcon":"fa fa-navicon","level1Icon":"","level2Icon":"","level3Icon":"","showLevelIcon":false},"mode":"float","multipleH1":true,"pageTop":{"level1Icon":"","level2Icon":"","level3Icon":"","showLevelIcon":false},"printLog":false,"showGoTop":true,"showLevel":true},"favicon":{"shortcut":"assets/images/favicon.ico","bookmark":"assets/images/favicon.ico"},"theme-comscore":{},"local-video":{},"copy-code-button":{},"sharing":{"all":["facebook","google","twitter","weibo","instapaper"],"facebook":true,"google":false,"instapaper":false,"twitter":true,"vk":false,"weibo":false},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":false},"search-plus":{}},"theme":"default","author":"Aivin","pdf":{"pageNumbers":true,"fontSize":12,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":62,"left":62,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"Aivin开发笔记","language":"zh-hans","gitbook":"*","description":"Aivin开发笔记"},"file":{"path":"chinese/mysql.md","mtime":"2019-01-18T02:23:15.546Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2019-04-12T07:41:34.135Z"},"basePath":"..","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="../gitbook/gitbook.js"></script>
    <script src="../gitbook/theme.js"></script>
    
        
        <script src="../gitbook/gitbook-plugin-search-plus/jquery.mark.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-search-plus/search.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-copy-code-button/toggle.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-donate/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-local-video/video.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-splitter/splitter.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-lunr/lunr.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-lunr/search-lunr.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-sharing/buttons.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-theme-comscore/test.js"></script>
        
    

    </body>
</html>

